Dashboard 02, 03 & 04 - Creating Drill Through Information Buttons 28

Next, we will set up the drill through information buttons.


Step 1:  Configure Drill Through in the ZipCode Dashboard page



In Power BI Desktop, click on the page, ZipCode

If selected, de-select a visualization by clicking an empty area of the report page.

Under Drill through ->  Cross-report -> Set it to OFF , Keep all filters ->  Set it to ON and add drag the following value underneath:

Township -> Township_Name




Step 2:  Configure Drill Through in the Township Dashboard page



In Power BI Desktop, click on the page, ZipCode

If selected, de-select a visualization by clicking an empty area of the report page.

Under Drill through ->  Cross-report -> Set it to OFF , Keep all filters ->  Set it to ON and add drag the following value underneath:

Table_AptPricePerUnit_PerPricePerSqFt ->  Physical_Zip_Code , Allow drill through when = Used as category
Property ->  Physical_Zip_Code , Allow drill through when = Used as category

Township -> Township_Name






Step 3:  Create a Drill Through Information Button on Dashboard 02

In Power BI Desktop, click on the page, WakeCountyRealEstate



Click Insert tab ->  Buttons and select Information



Visualizations

Click the Information  icon



Fields

N/A




Visualizations (Format button)



Under Visualizations (Format button) ->  General: X Position = 1320 , Y Position = 0 , Width = 180 , Height = 121

Under Visualizations (Format button) -> Button Text ->  Set it to OFF

Under Visualizations (Format button) -> Icon ->  Set it to ON = Default State  , Information , Padding = 4 , Vertical Alignment = Center , Horizontal Alignment = Center , Line Color = 000000 , Weight = 8 pt

Under Visualizations (Format button) -> Title ->  Set it to ON , Title Text = Drill Through 1 of 3 , Font Color = #1D0C4A , Background Color = E6E6E6 , Alignment = Center , Text Size = 17 pt , Font Family = DIN (Default)

Under Visualizations (Format button) ->  Background ->  Set it to ON , Color = #FFFFFF

Under Visualizations (Format button) ->  Border ->  Set it to ON , Color = #666666 , Radius = 5 px

Under Visualizations (Format button) ->  Action -> Type = Drill Through , Destination = ZipCode




Step 4:  Create a Drill Through Information Button on Dashboard 03, ZipCode

Copy the Information from Dashboard 02 and use it as a template.

Click on the 'Drill Through 1 of 3' from Dashboard 02 , press Ctrl+C to copy and Ctrl+V to paste it the 3rd Dashboard page, ZipCode

From the copied 'Drill Through 1 of 3' from Dashboard 02, ZipCode, to this dashboard, set up as follows:




Visualizations (Format button)

Under Visualizations (Format button) ->  General: X Position = 1320 , Y Position = 0 , Width = 180 , Height = 121

Under Visualizations (Format button) -> Button Text ->  Set it to OFF

Under Visualizations (Format button) -> Icon ->  Set it to ON = Default State  , Information , Padding = 4 , Vertical Alignment = Center , Horizontal Alignment = Center , Line Color = 000000 , Weight = 5 pt

Under Visualizations (Format button) -> Title ->  Set it to ON , Title Text = Drill Through 2 of 3 , Font Color = #1D0C4A , Background Color = E6E6E6 , Alignment = Center , Text Size = 17 pt , Font Family = DIN (Default)

Under Visualizations (Format button) ->  Background ->  Set it to ON , Color = #FFFFFF

Under Visualizations (Format button) ->  Border ->  Set it to ON , Color = #666666 , Radius = 5 px

Under Visualizations (Format button) ->  Action -> Type = Drill Through , Destination = Township





Step 5:  Create a Drill Through Information Button on Dashboard 04, Township

Click on the 'Drill Through 1 of 3' from Dashboard 02 , press Ctrl+C to copy and Ctrl+V to paste it the 3rd Dashboard page, Township

From the copied 'Drill Through 1 of 3' from Dashboard 02, WakeCountyRealEstate, to this dashboard, set up as follows:



Visualizations (Format button)

Under Visualizations (Format button) ->  General: X Position = 1320 , Y Position = 0 , Width = 180 , Height = 121

Under Visualizations (Format button) -> Button Text ->  Set it to OFF

Under Visualizations (Format button) -> Icon ->  Set it to ON = Default State  , Information , Padding = 4 , Vertical Alignment = Center , Horizontal Alignment = Center , Line Color = 000000 , Weight = 5 pt

Under Visualizations (Format button) -> Title ->  Set it to ON , Title Text = Drill Through 3 of 3 , Font Color = #1D0C4A , Background Color = E6E6E6 , Alignment = Center , Text Size = 17 pt , Font Family = DIN (Default)

Under Visualizations (Format button) ->  Background ->  Set it to ON , Color = #FFFFFF

Under Visualizations (Format button) ->  Border ->  Set it to ON , Color = #666666 , Radius = 5 px

Under Visualizations (Format button) ->  Action -> Set it to OFF



When finished, save project.



How to Set up drill through in Power BI reports